﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsAgriComer" targetNamespace="http://tempuri.org/dsAgriComer.xsd" xmlns:mstns="http://tempuri.org/dsAgriComer.xsd" xmlns="http://tempuri.org/dsAgriComer.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="agricomerConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="agricomerConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PL.Properties.Settings.GlobalReference.Default.agricomerConnectionString" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="catalogo_statusTableAdapter" GeneratorDataComponentClassName="catalogo_statusTableAdapter" Name="catalogo_status" UserDataComponentName="catalogo_statusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.catalogo_status" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `catalogo_status` WHERE ((`codigo` = @p1) AND ((@p2 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p3)) AND ((@p4 = 1 AND `status` IS NULL) OR (`status` = @p5)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `catalogo_status` (`descripcion`, `status`) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `codigo`, `descripcion`, `status` FROM `catalogo_status`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `catalogo_status` SET `descripcion` = @p1, `status` = @p2 WHERE ((`codigo` = @p3) AND ((@p4 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p5)) AND ((@p6 = 1 AND `status` IS NULL) OR (`status` = @p7)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="codigo" DataSetColumn="codigo" />
              <Mapping SourceColumn="descripcion" DataSetColumn="descripcion" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="clientesTableAdapter" GeneratorDataComponentClassName="clientesTableAdapter" Name="clientes" UserDataComponentName="clientesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.clientes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `clientes` WHERE ((`codigo` = @p1) AND ((@p2 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p3)) AND ((@p4 = 1 AND `nombre` IS NULL) OR (`nombre` = @p5)) AND ((@p6 = 1 AND `contacto` IS NULL) OR (`contacto` = @p7)) AND ((@p8 = 1 AND `telefono` IS NULL) OR (`telefono` = @p9)) AND ((@p10 = 1 AND `direccion` IS NULL) OR (`direccion` = @p11)) AND ((@p12 = 1 AND `rfc` IS NULL) OR (`rfc` = @p13)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="contacto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contacto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `clientes` (`descripcion`, `nombre`, `contacto`, `telefono`, `direccion`, `rfc`) VALUES (@p1, @p2, @p3, @p4, @p5, @p6)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contacto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `codigo`, `descripcion`, `nombre`, `contacto`, `telefono`, `direccion`, `rfc` FROM `clientes`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `clientes` SET `descripcion` = @p1, `nombre` = @p2, `contacto` = @p3, `telefono` = @p4, `direccion` = @p5, `rfc` = @p6 WHERE ((`codigo` = @p7) AND ((@p8 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p9)) AND ((@p10 = 1 AND `nombre` IS NULL) OR (`nombre` = @p11)) AND ((@p12 = 1 AND `contacto` IS NULL) OR (`contacto` = @p13)) AND ((@p14 = 1 AND `telefono` IS NULL) OR (`telefono` = @p15)) AND ((@p16 = 1 AND `direccion` IS NULL) OR (`direccion` = @p17)) AND ((@p18 = 1 AND `rfc` IS NULL) OR (`rfc` = @p19)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contacto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="contacto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contacto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p16" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p17" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p18" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p19" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="rfc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="codigo" DataSetColumn="codigo" />
              <Mapping SourceColumn="descripcion" DataSetColumn="descripcion" />
              <Mapping SourceColumn="nombre" DataSetColumn="nombre" />
              <Mapping SourceColumn="contacto" DataSetColumn="contacto" />
              <Mapping SourceColumn="telefono" DataSetColumn="telefono" />
              <Mapping SourceColumn="direccion" DataSetColumn="direccion" />
              <Mapping SourceColumn="rfc" DataSetColumn="rfc" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="cosechasTableAdapter" GeneratorDataComponentClassName="cosechasTableAdapter" Name="cosechas" UserDataComponentName="cosechasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.cosechas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `cosechas` WHERE ((`codigo` = @p1) AND ((@p2 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p3)) AND ((@p4 = 1 AND `temporada` IS NULL) OR (`temporada` = @p5)) AND ((@p6 = 1 AND `codigo_lote` IS NULL) OR (`codigo_lote` = @p7)) AND ((@p8 = 1 AND `codigo_producto` IS NULL) OR (`codigo_producto` = @p9)) AND ((@p10 = 1 AND `codigo_productor` IS NULL) OR (`codigo_productor` = @p11)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="temporada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="temporada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_lote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_lote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_producto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_productor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_productor" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `cosechas` (`descripcion`, `temporada`, `codigo_lote`, `codigo_producto`, `codigo_productor`) VALUES (@p1, @p2, @p3, @p4, @p5)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="temporada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_lote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_productor" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `codigo`, `descripcion`, `temporada`, `codigo_lote`, `codigo_producto`, `codigo_productor` FROM `cosechas`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `cosechas` SET `descripcion` = @p1, `temporada` = @p2, `codigo_lote` = @p3, `codigo_producto` = @p4, `codigo_productor` = @p5 WHERE ((`codigo` = @p6) AND ((@p7 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p8)) AND ((@p9 = 1 AND `temporada` IS NULL) OR (`temporada` = @p10)) AND ((@p11 = 1 AND `codigo_lote` IS NULL) OR (`codigo_lote` = @p12)) AND ((@p13 = 1 AND `codigo_producto` IS NULL) OR (`codigo_producto` = @p14)) AND ((@p15 = 1 AND `codigo_productor` IS NULL) OR (`codigo_productor` = @p16)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="temporada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_lote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_productor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="temporada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="temporada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_lote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_lote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_producto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_productor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p16" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="codigo_productor" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="codigo" DataSetColumn="codigo" />
              <Mapping SourceColumn="descripcion" DataSetColumn="descripcion" />
              <Mapping SourceColumn="temporada" DataSetColumn="temporada" />
              <Mapping SourceColumn="codigo_lote" DataSetColumn="codigo_lote" />
              <Mapping SourceColumn="codigo_producto" DataSetColumn="codigo_producto" />
              <Mapping SourceColumn="codigo_productor" DataSetColumn="codigo_productor" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="lotesTableAdapter" GeneratorDataComponentClassName="lotesTableAdapter" Name="lotes" UserDataComponentName="lotesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.lotes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `lotes` WHERE ((`codigo` = @p1) AND ((@p2 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p3)) AND ((@p4 = 1 AND `lote` IS NULL) OR (`lote` = @p5)) AND ((@p6 = 1 AND `seccion` IS NULL) OR (`seccion` = @p7)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="seccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="seccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `lotes` (`descripcion`, `lote`, `seccion`) VALUES (@p1, @p2, @p3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="seccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `codigo`, `descripcion`, `lote`, `seccion` FROM `lotes`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `lotes` SET `descripcion` = @p1, `lote` = @p2, `seccion` = @p3 WHERE ((`codigo` = @p4) AND ((@p5 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p6)) AND ((@p7 = 1 AND `lote` IS NULL) OR (`lote` = @p8)) AND ((@p9 = 1 AND `seccion` IS NULL) OR (`seccion` = @p10)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="seccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="seccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="seccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="codigo" DataSetColumn="codigo" />
              <Mapping SourceColumn="descripcion" DataSetColumn="descripcion" />
              <Mapping SourceColumn="lote" DataSetColumn="lote" />
              <Mapping SourceColumn="seccion" DataSetColumn="seccion" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="productoresTableAdapter" GeneratorDataComponentClassName="productoresTableAdapter" Name="productores" UserDataComponentName="productoresTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.productores" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `productores` WHERE ((`codigo` = @p1) AND ((@p2 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p3)) AND ((@p4 = 1 AND `nombre` IS NULL) OR (`nombre` = @p5)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `productores` (`descripcion`, `nombre`) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `codigo`, `descripcion`, `nombre` FROM `productores`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `productores` SET `descripcion` = @p1, `nombre` = @p2 WHERE ((`codigo` = @p3) AND ((@p4 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p5)) AND ((@p6 = 1 AND `nombre` IS NULL) OR (`nombre` = @p7)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="codigo" DataSetColumn="codigo" />
              <Mapping SourceColumn="descripcion" DataSetColumn="descripcion" />
              <Mapping SourceColumn="nombre" DataSetColumn="nombre" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="productosTableAdapter" GeneratorDataComponentClassName="productosTableAdapter" Name="productos" UserDataComponentName="productosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.productos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `productos` WHERE ((`codigo` = @p1) AND ((@p2 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p3)) AND ((@p4 = 1 AND `producto` IS NULL) OR (`producto` = @p5)) AND ((@p6 = 1 AND `variedad` IS NULL) OR (`variedad` = @p7)) AND ((@p8 = 1 AND `medida` IS NULL) OR (`medida` = @p9)) AND ((@p10 = 1 AND `marca` IS NULL) OR (`marca` = @p11)) AND ((@p12 = 1 AND `existencia` IS NULL) OR (`existencia` = @p13)) AND ((@p14 = 1 AND `unidad` IS NULL) OR (`unidad` = @p15)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="variedad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="variedad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="medida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="medida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="marca" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="marca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="existencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="existencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `productos` (`descripcion`, `producto`, `variedad`, `medida`, `marca`, `existencia`, `unidad`) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="variedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="medida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="marca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="existencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `codigo`, `descripcion`, `producto`, `variedad`, `medida`, `marca`, `existencia`, `unidad` FROM `productos`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `productos` SET `descripcion` = @p1, `producto` = @p2, `variedad` = @p3, `medida` = @p4, `marca` = @p5, `existencia` = @p6, `unidad` = @p7 WHERE ((`codigo` = @p8) AND ((@p9 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p10)) AND ((@p11 = 1 AND `producto` IS NULL) OR (`producto` = @p12)) AND ((@p13 = 1 AND `variedad` IS NULL) OR (`variedad` = @p14)) AND ((@p15 = 1 AND `medida` IS NULL) OR (`medida` = @p16)) AND ((@p17 = 1 AND `marca` IS NULL) OR (`marca` = @p18)) AND ((@p19 = 1 AND `existencia` IS NULL) OR (`existencia` = @p20)) AND ((@p21 = 1 AND `unidad` IS NULL) OR (`unidad` = @p22)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="variedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="medida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="marca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="existencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="variedad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="variedad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="medida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p16" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="medida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p17" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="marca" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p18" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="marca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p19" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="existencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p20" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="existencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p21" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p22" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="codigo" DataSetColumn="codigo" />
              <Mapping SourceColumn="descripcion" DataSetColumn="descripcion" />
              <Mapping SourceColumn="producto" DataSetColumn="producto" />
              <Mapping SourceColumn="variedad" DataSetColumn="variedad" />
              <Mapping SourceColumn="medida" DataSetColumn="medida" />
              <Mapping SourceColumn="marca" DataSetColumn="marca" />
              <Mapping SourceColumn="existencia" DataSetColumn="existencia" />
              <Mapping SourceColumn="unidad" DataSetColumn="unidad" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="unidades_medidaTableAdapter" GeneratorDataComponentClassName="unidades_medidaTableAdapter" Name="unidades_medida" UserDataComponentName="unidades_medidaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.unidades_medida" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `unidades_medida` WHERE ((`codigo` = @p1) AND ((@p2 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p3)) AND ((@p4 = 1 AND `unidad` IS NULL) OR (`unidad` = @p5)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `unidades_medida` (`descripcion`, `unidad`) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `codigo`, `descripcion`, `unidad` FROM `unidades_medida`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `unidades_medida` SET `descripcion` = @p1, `unidad` = @p2 WHERE ((`codigo` = @p3) AND ((@p4 = 1 AND `descripcion` IS NULL) OR (`descripcion` = @p5)) AND ((@p6 = 1 AND `unidad` IS NULL) OR (`unidad` = @p7)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="unidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="codigo" DataSetColumn="codigo" />
              <Mapping SourceColumn="descripcion" DataSetColumn="descripcion" />
              <Mapping SourceColumn="unidad" DataSetColumn="unidad" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ventasTableAdapter" GeneratorDataComponentClassName="ventasTableAdapter" Name="ventas" UserDataComponentName="ventasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.ventas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ventas` WHERE ((`folio` = @p1) AND ((@p2 = 1 AND `venta_tipo` IS NULL) OR (`venta_tipo` = @p3)) AND ((@p4 = 1 AND `viaje_status` IS NULL) OR (`viaje_status` = @p5)) AND ((@p6 = 1 AND `viaje_folio` IS NULL) OR (`viaje_folio` = @p7)) AND ((@p8 = 1 AND `viaje_fecha` IS NULL) OR (`viaje_fecha` = @p9)) AND ((@p10 = 1 AND `viaje_dia` IS NULL) OR (`viaje_dia` = @p11)) AND ((@p12 = 1 AND `viaje_referencia` IS NULL) OR (`viaje_referencia` = @p13)) AND ((@p14 = 1 AND `producto_codigo` IS NULL) OR (`producto_codigo` = @p15)) AND ((@p16 = 1 AND `producto_descripcion` IS NULL) OR (`producto_descripcion` = @p17)) AND ((@p18 = 1 AND `producto_variedad` IS NULL) OR (`producto_variedad` = @p19)) AND ((@p20 = 1 AND `producto_medida` IS NULL) OR (`producto_medida` = @p21)) AND ((@p22 = 1 AND `producto_tipo` IS NULL) OR (`producto_tipo` = @p23)) AND ((@p24 = 1 AND `producto_marca` IS NULL) OR (`producto_marca` = @p25)) AND ((@p26 = 1 AND `lote_codigo` IS NULL) OR (`lote_codigo` = @p27)) AND ((@p28 = 1 AND `lote_descripcion` IS NULL) OR (`lote_descripcion` = @p29)) AND ((@p30 = 1 AND `lote_lote` IS NULL) OR (`lote_lote` = @p31)) AND ((@p32 = 1 AND `lote_seccion` IS NULL) OR (`lote_seccion` = @p33)) AND ((@p34 = 1 AND `productor_codigo` IS NULL) OR (`productor_codigo` = @p35)) AND ((@p36 = 1 AND `productor_descripcion` IS NULL) OR (`productor_descripcion` = @p37)) AND ((@p38 = 1 AND `destino_cliente_codigo` IS NULL) OR (`destino_cliente_codigo` = @p39)) AND ((@p40 = 1 AND `destino_nombre` IS NULL) OR (`destino_nombre` = @p41)) AND ((@p42 = 1 AND `destino_localizacion` IS NULL) OR (`destino_localizacion` = @p43)) AND ((@p44 = 1 AND `embarque_fletero` IS NULL) OR (`embarque_fletero` = @p45)) AND ((@p46 = 1 AND `embarque_presentacion` IS NULL) OR (`embarque_presentacion` = @p47)) AND ((@p48 = 1 AND `embarque_unidades` IS NULL) OR (`embarque_unidades` = @p49)) AND ((@p50 = 1 AND `embarque_kgunidad` IS NULL) OR (`embarque_kgunidad` = @p51)) AND ((@p52 = 1 AND `embarque_kgembarque` IS NULL) OR (`embarque_kgembarque` = @p53)) AND ((@p54 = 1 AND `recepcion_unidades` IS NULL) OR (`recepcion_unidades` = @p55)) AND ((@p56 = 1 AND `recepcion_kgunidad` IS NULL) OR (`recepcion_kgunidad` = @p57)) AND ((@p58 = 1 AND `recepcion_kgembarque` IS NULL) OR (`recepcion_kgembarque` = @p59)) AND ((@p60 = 1 AND `merma_kgunidad` IS NULL) OR (`merma_kgunidad` = @p61)) AND ((@p62 = 1 AND `merma_kgembarque` IS NULL) OR (`merma_kgembarque` = @p63)) AND ((@p64 = 1 AND `precio_productor` IS NULL) OR (`precio_productor` = @p65)) AND ((@p66 = 1 AND `precio_cliente` IS NULL) OR (`precio_cliente` = @p67)) AND ((@p68 = 1 AND `precio_real` IS NULL) OR (`precio_real` = @p69)) AND ((@p70 = 1 AND `a_pagar_kgembarque` IS NULL) OR (`a_pagar_kgembarque` = @p71)) AND ((@p72 = 1 AND `a_pagar_kgunidad` IS NULL) OR (`a_pagar_kgunidad` = @p73)) AND ((@p74 = 1 AND `a_pagar_importe` IS NULL) OR (`a_pagar_importe` = @p75)) AND ((@p76 = 1 AND `pagos_fgs` IS NULL) OR (`pagos_fgs` = @p77)) AND ((@p78 = 1 AND `pagos_socios` IS NULL) OR (`pagos_socios` = @p79)) AND ((@p80 = 1 AND `saldo_cliente` IS NULL) OR (`saldo_cliente` = @p81)) AND ((@p82 = 1 AND `ventas_fgs` IS NULL) OR (`ventas_fgs` = @p83)) AND ((@p84 = 1 AND `xcobrar_fgs` IS NULL) OR (`xcobrar_fgs` = @p85)) AND ((@p86 = 1 AND `ventas_socio` IS NULL) OR (`ventas_socio` = @p87)) AND ((@p88 = 1 AND `xcobrar_socio` IS NULL) OR (`xcobrar_socio` = @p89)) AND ((@p90 = 1 AND `semilla_int` IS NULL) OR (`semilla_int` = @p91)) AND ((@p92 = 1 AND `bodega` IS NULL) OR (`bodega` = @p93)) AND ((@p94 = 1 AND `venta_importe` IS NULL) OR (`venta_importe` = @p95)) AND ((@p96 = 1 AND `venta_pagado` IS NULL) OR (`venta_pagado` = @p97)) AND ((@p98 = 1 AND `venta_saldo` IS NULL) OR (`venta_saldo` = @p99)) AND ((@p100 = 1 AND `fgs_importe` IS NULL) OR (`fgs_importe` = @p101)) AND ((@p102 = 1 AND `fgs_pagado` IS NULL) OR (`fgs_pagado` = @p103)) AND ((@p104 = 1 AND `fgs_saldo` IS NULL) OR (`fgs_saldo` = @p105)) AND ((@p106 = 1 AND `socio_importe` IS NULL) OR (`socio_importe` = @p107)) AND ((@p108 = 1 AND `socio_pagado` IS NULL) OR (`socio_pagado` = @p109)) AND ((@p110 = 1 AND `socio_saldo` IS NULL) OR (`socio_saldo` = @p111)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="folio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="venta_tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="venta_tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="viaje_status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="viaje_folio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="viaje_folio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="viaje_fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="viaje_fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="viaje_dia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_dia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="viaje_referencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_referencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_codigo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="producto_codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p16" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p17" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p18" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_variedad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p19" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_variedad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p20" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_medida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p21" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_medida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p22" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p23" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p24" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_marca" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p25" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_marca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p26" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lote_codigo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p27" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="lote_codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p28" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lote_descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p29" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p30" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lote_lote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p31" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_lote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p32" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lote_seccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p33" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_seccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p34" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="productor_codigo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p35" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="productor_codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p36" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="productor_descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p37" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="productor_descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p38" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="destino_cliente_codigo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p39" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="destino_cliente_codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p40" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="destino_nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p41" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="destino_nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p42" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="destino_localizacion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p43" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="destino_localizacion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p44" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="embarque_fletero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p45" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="embarque_fletero" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p46" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="embarque_presentacion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p47" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="embarque_presentacion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p48" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="embarque_unidades" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p49" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_unidades" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p50" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="embarque_kgunidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p51" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_kgunidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p52" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="embarque_kgembarque" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p53" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_kgembarque" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p54" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="recepcion_unidades" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p55" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_unidades" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p56" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="recepcion_kgunidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p57" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_kgunidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p58" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="recepcion_kgembarque" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p59" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_kgembarque" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p60" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="merma_kgunidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p61" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="merma_kgunidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p62" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="merma_kgembarque" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p63" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="merma_kgembarque" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p64" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="precio_productor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p65" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_productor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p66" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="precio_cliente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p67" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_cliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p68" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="precio_real" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p69" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_real" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p70" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="a_pagar_kgembarque" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p71" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_kgembarque" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p72" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="a_pagar_kgunidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p73" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_kgunidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p74" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="a_pagar_importe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p75" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_importe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p76" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pagos_fgs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p77" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pagos_fgs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p78" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pagos_socios" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p79" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pagos_socios" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p80" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="saldo_cliente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p81" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="saldo_cliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p82" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ventas_fgs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p83" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ventas_fgs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p84" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="xcobrar_fgs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p85" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="xcobrar_fgs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p86" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ventas_socio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p87" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ventas_socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p88" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="xcobrar_socio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p89" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="xcobrar_socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p90" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="semilla_int" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p91" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="semilla_int" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p92" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bodega" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p93" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p94" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="venta_importe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p95" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_importe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p96" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="venta_pagado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p97" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_pagado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p98" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="venta_saldo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p99" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_saldo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p100" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="fgs_importe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p101" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_importe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p102" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="fgs_pagado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p103" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_pagado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p104" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="fgs_saldo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p105" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_saldo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p106" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="socio_importe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p107" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_importe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p108" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="socio_pagado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p109" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_pagado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p110" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="socio_saldo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p111" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_saldo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ventas` (`venta_tipo`, `viaje_status`, `viaje_folio`, `viaje_fecha`, `viaje_dia`, `viaje_referencia`, `producto_codigo`, `producto_descripcion`, `producto_variedad`, `producto_medida`, `producto_tipo`, `producto_marca`, `lote_codigo`, `lote_descripcion`, `lote_lote`, `lote_seccion`, `productor_codigo`, `productor_descripcion`, `destino_cliente_codigo`, `destino_nombre`, `destino_localizacion`, `embarque_fletero`, `embarque_presentacion`, `embarque_unidades`, `embarque_kgunidad`, `embarque_kgembarque`, `recepcion_unidades`, `recepcion_kgunidad`, `recepcion_kgembarque`, `merma_kgunidad`, `merma_kgembarque`, `precio_productor`, `precio_cliente`, `precio_real`, `a_pagar_kgembarque`, `a_pagar_kgunidad`, `a_pagar_importe`, `pagos_fgs`, `pagos_socios`, `saldo_cliente`, `ventas_fgs`, `xcobrar_fgs`, `ventas_socio`, `xcobrar_socio`, `semilla_int`, `bodega`, `venta_importe`, `venta_pagado`, `venta_saldo`, `fgs_importe`, `fgs_pagado`, `fgs_saldo`, `socio_importe`, `socio_pagado`, `socio_saldo`) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, @p54, @p55)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="venta_tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="viaje_folio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="viaje_fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_dia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_referencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="producto_codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_variedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_medida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_marca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="lote_codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_lote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p16" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_seccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p17" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="productor_codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p18" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="productor_descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p19" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="destino_cliente_codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p20" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="destino_nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p21" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="destino_localizacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p22" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="embarque_fletero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p23" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="embarque_presentacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p24" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_unidades" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p25" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_kgunidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p26" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_kgembarque" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p27" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_unidades" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p28" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_kgunidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p29" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_kgembarque" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p30" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="merma_kgunidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p31" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="merma_kgembarque" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p32" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_productor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p33" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p34" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_real" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p35" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_kgembarque" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p36" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_kgunidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p37" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_importe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p38" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pagos_fgs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p39" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pagos_socios" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p40" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="saldo_cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p41" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ventas_fgs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p42" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="xcobrar_fgs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p43" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ventas_socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p44" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="xcobrar_socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p45" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="semilla_int" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p46" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p47" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_importe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p48" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_pagado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p49" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_saldo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p50" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_importe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p51" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_pagado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p52" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_saldo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p53" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_importe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p54" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_pagado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p55" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_saldo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `folio`, `venta_tipo`, `viaje_status`, `viaje_folio`, `viaje_fecha`, `viaje_dia`, `viaje_referencia`, `producto_codigo`, `producto_descripcion`, `producto_variedad`, `producto_medida`, `producto_tipo`, `producto_marca`, `lote_codigo`, `lote_descripcion`, `lote_lote`, `lote_seccion`, `productor_codigo`, `productor_descripcion`, `destino_cliente_codigo`, `destino_nombre`, `destino_localizacion`, `embarque_fletero`, `embarque_presentacion`, `embarque_unidades`, `embarque_kgunidad`, `embarque_kgembarque`, `recepcion_unidades`, `recepcion_kgunidad`, `recepcion_kgembarque`, `merma_kgunidad`, `merma_kgembarque`, `precio_productor`, `precio_cliente`, `precio_real`, `a_pagar_kgembarque`, `a_pagar_kgunidad`, `a_pagar_importe`, `pagos_fgs`, `pagos_socios`, `saldo_cliente`, `ventas_fgs`, `xcobrar_fgs`, `ventas_socio`, `xcobrar_socio`, `semilla_int`, `bodega`, `venta_importe`, `venta_pagado`, `venta_saldo`, `fgs_importe`, `fgs_pagado`, `fgs_saldo`, `socio_importe`, `socio_pagado`, `socio_saldo` FROM `ventas`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ventas` SET `venta_tipo` = @p1, `viaje_status` = @p2, `viaje_folio` = @p3, `viaje_fecha` = @p4, `viaje_dia` = @p5, `viaje_referencia` = @p6, `producto_codigo` = @p7, `producto_descripcion` = @p8, `producto_variedad` = @p9, `producto_medida` = @p10, `producto_tipo` = @p11, `producto_marca` = @p12, `lote_codigo` = @p13, `lote_descripcion` = @p14, `lote_lote` = @p15, `lote_seccion` = @p16, `productor_codigo` = @p17, `productor_descripcion` = @p18, `destino_cliente_codigo` = @p19, `destino_nombre` = @p20, `destino_localizacion` = @p21, `embarque_fletero` = @p22, `embarque_presentacion` = @p23, `embarque_unidades` = @p24, `embarque_kgunidad` = @p25, `embarque_kgembarque` = @p26, `recepcion_unidades` = @p27, `recepcion_kgunidad` = @p28, `recepcion_kgembarque` = @p29, `merma_kgunidad` = @p30, `merma_kgembarque` = @p31, `precio_productor` = @p32, `precio_cliente` = @p33, `precio_real` = @p34, `a_pagar_kgembarque` = @p35, `a_pagar_kgunidad` = @p36, `a_pagar_importe` = @p37, `pagos_fgs` = @p38, `pagos_socios` = @p39, `saldo_cliente` = @p40, `ventas_fgs` = @p41, `xcobrar_fgs` = @p42, `ventas_socio` = @p43, `xcobrar_socio` = @p44, `semilla_int` = @p45, `bodega` = @p46, `venta_importe` = @p47, `venta_pagado` = @p48, `venta_saldo` = @p49, `fgs_importe` = @p50, `fgs_pagado` = @p51, `fgs_saldo` = @p52, `socio_importe` = @p53, `socio_pagado` = @p54, `socio_saldo` = @p55 WHERE ((`folio` = @p56) AND ((@p57 = 1 AND `venta_tipo` IS NULL) OR (`venta_tipo` = @p58)) AND ((@p59 = 1 AND `viaje_status` IS NULL) OR (`viaje_status` = @p60)) AND ((@p61 = 1 AND `viaje_folio` IS NULL) OR (`viaje_folio` = @p62)) AND ((@p63 = 1 AND `viaje_fecha` IS NULL) OR (`viaje_fecha` = @p64)) AND ((@p65 = 1 AND `viaje_dia` IS NULL) OR (`viaje_dia` = @p66)) AND ((@p67 = 1 AND `viaje_referencia` IS NULL) OR (`viaje_referencia` = @p68)) AND ((@p69 = 1 AND `producto_codigo` IS NULL) OR (`producto_codigo` = @p70)) AND ((@p71 = 1 AND `producto_descripcion` IS NULL) OR (`producto_descripcion` = @p72)) AND ((@p73 = 1 AND `producto_variedad` IS NULL) OR (`producto_variedad` = @p74)) AND ((@p75 = 1 AND `producto_medida` IS NULL) OR (`producto_medida` = @p76)) AND ((@p77 = 1 AND `producto_tipo` IS NULL) OR (`producto_tipo` = @p78)) AND ((@p79 = 1 AND `producto_marca` IS NULL) OR (`producto_marca` = @p80)) AND ((@p81 = 1 AND `lote_codigo` IS NULL) OR (`lote_codigo` = @p82)) AND ((@p83 = 1 AND `lote_descripcion` IS NULL) OR (`lote_descripcion` = @p84)) AND ((@p85 = 1 AND `lote_lote` IS NULL) OR (`lote_lote` = @p86)) AND ((@p87 = 1 AND `lote_seccion` IS NULL) OR (`lote_seccion` = @p88)) AND ((@p89 = 1 AND `productor_codigo` IS NULL) OR (`productor_codigo` = @p90)) AND ((@p91 = 1 AND `productor_descripcion` IS NULL) OR (`productor_descripcion` = @p92)) AND ((@p93 = 1 AND `destino_cliente_codigo` IS NULL) OR (`destino_cliente_codigo` = @p94)) AND ((@p95 = 1 AND `destino_nombre` IS NULL) OR (`destino_nombre` = @p96)) AND ((@p97 = 1 AND `destino_localizacion` IS NULL) OR (`destino_localizacion` = @p98)) AND ((@p99 = 1 AND `embarque_fletero` IS NULL) OR (`embarque_fletero` = @p100)) AND ((@p101 = 1 AND `embarque_presentacion` IS NULL) OR (`embarque_presentacion` = @p102)) AND ((@p103 = 1 AND `embarque_unidades` IS NULL) OR (`embarque_unidades` = @p104)) AND ((@p105 = 1 AND `embarque_kgunidad` IS NULL) OR (`embarque_kgunidad` = @p106)) AND ((@p107 = 1 AND `embarque_kgembarque` IS NULL) OR (`embarque_kgembarque` = @p108)) AND ((@p109 = 1 AND `recepcion_unidades` IS NULL) OR (`recepcion_unidades` = @p110)) AND ((@p111 = 1 AND `recepcion_kgunidad` IS NULL) OR (`recepcion_kgunidad` = @p112)) AND ((@p113 = 1 AND `recepcion_kgembarque` IS NULL) OR (`recepcion_kgembarque` = @p114)) AND ((@p115 = 1 AND `merma_kgunidad` IS NULL) OR (`merma_kgunidad` = @p116)) AND ((@p117 = 1 AND `merma_kgembarque` IS NULL) OR (`merma_kgembarque` = @p118)) AND ((@p119 = 1 AND `precio_productor` IS NULL) OR (`precio_productor` = @p120)) AND ((@p121 = 1 AND `precio_cliente` IS NULL) OR (`precio_cliente` = @p122)) AND ((@p123 = 1 AND `precio_real` IS NULL) OR (`precio_real` = @p124)) AND ((@p125 = 1 AND `a_pagar_kgembarque` IS NULL) OR (`a_pagar_kgembarque` = @p126)) AND ((@p127 = 1 AND `a_pagar_kgunidad` IS NULL) OR (`a_pagar_kgunidad` = @p128)) AND ((@p129 = 1 AND `a_pagar_importe` IS NULL) OR (`a_pagar_importe` = @p130)) AND ((@p131 = 1 AND `pagos_fgs` IS NULL) OR (`pagos_fgs` = @p132)) AND ((@p133 = 1 AND `pagos_socios` IS NULL) OR (`pagos_socios` = @p134)) AND ((@p135 = 1 AND `saldo_cliente` IS NULL) OR (`saldo_cliente` = @p136)) AND ((@p137 = 1 AND `ventas_fgs` IS NULL) OR (`ventas_fgs` = @p138)) AND ((@p139 = 1 AND `xcobrar_fgs` IS NULL) OR (`xcobrar_fgs` = @p140)) AND ((@p141 = 1 AND `ventas_socio` IS NULL) OR (`ventas_socio` = @p142)) AND ((@p143 = 1 AND `xcobrar_socio` IS NULL) OR (`xcobrar_socio` = @p144)) AND ((@p145 = 1 AND `semilla_int` IS NULL) OR (`semilla_int` = @p146)) AND ((@p147 = 1 AND `bodega` IS NULL) OR (`bodega` = @p148)) AND ((@p149 = 1 AND `venta_importe` IS NULL) OR (`venta_importe` = @p150)) AND ((@p151 = 1 AND `venta_pagado` IS NULL) OR (`venta_pagado` = @p152)) AND ((@p153 = 1 AND `venta_saldo` IS NULL) OR (`venta_saldo` = @p154)) AND ((@p155 = 1 AND `fgs_importe` IS NULL) OR (`fgs_importe` = @p156)) AND ((@p157 = 1 AND `fgs_pagado` IS NULL) OR (`fgs_pagado` = @p158)) AND ((@p159 = 1 AND `fgs_saldo` IS NULL) OR (`fgs_saldo` = @p160)) AND ((@p161 = 1 AND `socio_importe` IS NULL) OR (`socio_importe` = @p162)) AND ((@p163 = 1 AND `socio_pagado` IS NULL) OR (`socio_pagado` = @p164)) AND ((@p165 = 1 AND `socio_saldo` IS NULL) OR (`socio_saldo` = @p166)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="venta_tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="viaje_folio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="viaje_fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_dia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_referencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="producto_codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_variedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_medida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_marca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="lote_codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_lote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p16" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_seccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p17" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="productor_codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p18" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="productor_descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p19" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="destino_cliente_codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p20" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="destino_nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p21" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="destino_localizacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p22" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="embarque_fletero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p23" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="embarque_presentacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p24" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_unidades" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p25" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_kgunidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p26" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_kgembarque" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p27" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_unidades" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p28" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_kgunidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p29" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_kgembarque" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p30" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="merma_kgunidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p31" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="merma_kgembarque" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p32" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_productor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p33" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p34" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_real" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p35" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_kgembarque" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p36" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_kgunidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p37" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_importe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p38" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pagos_fgs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p39" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pagos_socios" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p40" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="saldo_cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p41" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ventas_fgs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p42" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="xcobrar_fgs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p43" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ventas_socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p44" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="xcobrar_socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p45" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="semilla_int" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p46" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p47" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_importe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p48" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_pagado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p49" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_saldo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p50" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_importe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p51" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_pagado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p52" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_saldo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p53" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_importe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p54" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_pagado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p55" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_saldo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p56" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="folio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p57" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="venta_tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p58" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="venta_tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p59" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="viaje_status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p60" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p61" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="viaje_folio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p62" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="viaje_folio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p63" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="viaje_fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p64" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="viaje_fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p65" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="viaje_dia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p66" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_dia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p67" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="viaje_referencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p68" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="viaje_referencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p69" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_codigo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p70" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="producto_codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p71" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p72" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p73" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_variedad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p74" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_variedad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p75" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_medida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p76" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_medida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p77" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p78" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p79" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="producto_marca" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p80" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="producto_marca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p81" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lote_codigo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p82" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="lote_codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p83" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lote_descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p84" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p85" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lote_lote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p86" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_lote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p87" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lote_seccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p88" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lote_seccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p89" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="productor_codigo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p90" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="productor_codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p91" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="productor_descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p92" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="productor_descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p93" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="destino_cliente_codigo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@p94" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="destino_cliente_codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p95" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="destino_nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p96" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="destino_nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p97" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="destino_localizacion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p98" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="destino_localizacion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p99" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="embarque_fletero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p100" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="embarque_fletero" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p101" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="embarque_presentacion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p102" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="embarque_presentacion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p103" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="embarque_unidades" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p104" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_unidades" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p105" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="embarque_kgunidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p106" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_kgunidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p107" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="embarque_kgembarque" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p108" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="embarque_kgembarque" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p109" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="recepcion_unidades" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p110" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_unidades" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p111" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="recepcion_kgunidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p112" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_kgunidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p113" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="recepcion_kgembarque" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p114" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="recepcion_kgembarque" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p115" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="merma_kgunidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p116" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="merma_kgunidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p117" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="merma_kgembarque" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p118" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="merma_kgembarque" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p119" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="precio_productor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p120" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_productor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p121" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="precio_cliente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p122" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_cliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p123" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="precio_real" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p124" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="precio_real" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p125" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="a_pagar_kgembarque" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p126" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_kgembarque" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p127" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="a_pagar_kgunidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p128" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_kgunidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p129" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="a_pagar_importe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p130" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="a_pagar_importe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p131" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pagos_fgs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p132" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pagos_fgs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p133" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pagos_socios" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p134" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pagos_socios" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p135" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="saldo_cliente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p136" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="saldo_cliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p137" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ventas_fgs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p138" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ventas_fgs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p139" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="xcobrar_fgs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p140" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="xcobrar_fgs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p141" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ventas_socio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p142" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ventas_socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p143" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="xcobrar_socio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p144" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="xcobrar_socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p145" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="semilla_int" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p146" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="semilla_int" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p147" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bodega" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p148" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p149" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="venta_importe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p150" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_importe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p151" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="venta_pagado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p152" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_pagado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p153" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="venta_saldo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p154" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="venta_saldo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p155" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="fgs_importe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p156" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_importe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p157" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="fgs_pagado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p158" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_pagado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p159" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="fgs_saldo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p160" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="fgs_saldo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p161" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="socio_importe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p162" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_importe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p163" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="socio_pagado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p164" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_pagado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p165" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="socio_saldo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p166" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="socio_saldo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="folio" DataSetColumn="folio" />
              <Mapping SourceColumn="venta_tipo" DataSetColumn="venta_tipo" />
              <Mapping SourceColumn="viaje_status" DataSetColumn="viaje_status" />
              <Mapping SourceColumn="viaje_folio" DataSetColumn="viaje_folio" />
              <Mapping SourceColumn="viaje_fecha" DataSetColumn="viaje_fecha" />
              <Mapping SourceColumn="viaje_dia" DataSetColumn="viaje_dia" />
              <Mapping SourceColumn="viaje_referencia" DataSetColumn="viaje_referencia" />
              <Mapping SourceColumn="producto_codigo" DataSetColumn="producto_codigo" />
              <Mapping SourceColumn="producto_descripcion" DataSetColumn="producto_descripcion" />
              <Mapping SourceColumn="producto_variedad" DataSetColumn="producto_variedad" />
              <Mapping SourceColumn="producto_medida" DataSetColumn="producto_medida" />
              <Mapping SourceColumn="producto_tipo" DataSetColumn="producto_tipo" />
              <Mapping SourceColumn="producto_marca" DataSetColumn="producto_marca" />
              <Mapping SourceColumn="lote_codigo" DataSetColumn="lote_codigo" />
              <Mapping SourceColumn="lote_descripcion" DataSetColumn="lote_descripcion" />
              <Mapping SourceColumn="lote_lote" DataSetColumn="lote_lote" />
              <Mapping SourceColumn="lote_seccion" DataSetColumn="lote_seccion" />
              <Mapping SourceColumn="productor_codigo" DataSetColumn="productor_codigo" />
              <Mapping SourceColumn="productor_descripcion" DataSetColumn="productor_descripcion" />
              <Mapping SourceColumn="destino_cliente_codigo" DataSetColumn="destino_cliente_codigo" />
              <Mapping SourceColumn="destino_nombre" DataSetColumn="destino_nombre" />
              <Mapping SourceColumn="destino_localizacion" DataSetColumn="destino_localizacion" />
              <Mapping SourceColumn="embarque_fletero" DataSetColumn="embarque_fletero" />
              <Mapping SourceColumn="embarque_presentacion" DataSetColumn="embarque_presentacion" />
              <Mapping SourceColumn="embarque_unidades" DataSetColumn="embarque_unidades" />
              <Mapping SourceColumn="embarque_kgunidad" DataSetColumn="embarque_kgunidad" />
              <Mapping SourceColumn="embarque_kgembarque" DataSetColumn="embarque_kgembarque" />
              <Mapping SourceColumn="recepcion_unidades" DataSetColumn="recepcion_unidades" />
              <Mapping SourceColumn="recepcion_kgunidad" DataSetColumn="recepcion_kgunidad" />
              <Mapping SourceColumn="recepcion_kgembarque" DataSetColumn="recepcion_kgembarque" />
              <Mapping SourceColumn="merma_kgunidad" DataSetColumn="merma_kgunidad" />
              <Mapping SourceColumn="merma_kgembarque" DataSetColumn="merma_kgembarque" />
              <Mapping SourceColumn="precio_productor" DataSetColumn="precio_productor" />
              <Mapping SourceColumn="precio_cliente" DataSetColumn="precio_cliente" />
              <Mapping SourceColumn="precio_real" DataSetColumn="precio_real" />
              <Mapping SourceColumn="a_pagar_kgembarque" DataSetColumn="a_pagar_kgembarque" />
              <Mapping SourceColumn="a_pagar_kgunidad" DataSetColumn="a_pagar_kgunidad" />
              <Mapping SourceColumn="a_pagar_importe" DataSetColumn="a_pagar_importe" />
              <Mapping SourceColumn="pagos_fgs" DataSetColumn="pagos_fgs" />
              <Mapping SourceColumn="pagos_socios" DataSetColumn="pagos_socios" />
              <Mapping SourceColumn="saldo_cliente" DataSetColumn="saldo_cliente" />
              <Mapping SourceColumn="ventas_fgs" DataSetColumn="ventas_fgs" />
              <Mapping SourceColumn="xcobrar_fgs" DataSetColumn="xcobrar_fgs" />
              <Mapping SourceColumn="ventas_socio" DataSetColumn="ventas_socio" />
              <Mapping SourceColumn="xcobrar_socio" DataSetColumn="xcobrar_socio" />
              <Mapping SourceColumn="semilla_int" DataSetColumn="semilla_int" />
              <Mapping SourceColumn="bodega" DataSetColumn="bodega" />
              <Mapping SourceColumn="venta_importe" DataSetColumn="venta_importe" />
              <Mapping SourceColumn="venta_pagado" DataSetColumn="venta_pagado" />
              <Mapping SourceColumn="venta_saldo" DataSetColumn="venta_saldo" />
              <Mapping SourceColumn="fgs_importe" DataSetColumn="fgs_importe" />
              <Mapping SourceColumn="fgs_pagado" DataSetColumn="fgs_pagado" />
              <Mapping SourceColumn="fgs_saldo" DataSetColumn="fgs_saldo" />
              <Mapping SourceColumn="socio_importe" DataSetColumn="socio_importe" />
              <Mapping SourceColumn="socio_pagado" DataSetColumn="socio_pagado" />
              <Mapping SourceColumn="socio_saldo" DataSetColumn="socio_saldo" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.ventas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByBodega" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByBodega" GeneratorSourceName="FillByBodega" GetMethodModifier="Public" GetMethodName="GetDataByBodega" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByBodega" UserSourceName="FillByBodega">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        folio, venta_tipo, viaje_status, viaje_folio, viaje_fecha, viaje_dia, viaje_referencia, producto_codigo, producto_descripcion, producto_variedad, producto_medida, producto_tipo, producto_marca, lote_codigo, 
                         lote_descripcion, lote_lote, lote_seccion, productor_codigo, productor_descripcion, destino_cliente_codigo, destino_nombre, destino_localizacion, embarque_fletero, embarque_presentacion, 
                         embarque_unidades, embarque_kgunidad, embarque_kgembarque, recepcion_unidades, recepcion_kgunidad, recepcion_kgembarque, merma_kgunidad, merma_kgembarque, precio_productor, precio_cliente, 
                         precio_real, a_pagar_kgembarque, a_pagar_kgunidad, a_pagar_importe, pagos_fgs, pagos_socios, saldo_cliente, ventas_fgs, xcobrar_fgs, ventas_socio, xcobrar_socio, semilla_int, bodega, venta_importe, 
                         venta_pagado, venta_saldo, fgs_importe, fgs_pagado, fgs_saldo, socio_importe, socio_pagado, socio_saldo
FROM            ventas
WHERE        (viaje_status = 'BODEGA')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.ventas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByComercial" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByComercial" GeneratorSourceName="FillByComercial" GetMethodModifier="Public" GetMethodName="GetDataByComercial" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByComercial" UserSourceName="FillByComercial">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        folio, venta_tipo, viaje_status, viaje_folio, viaje_fecha, viaje_dia, viaje_referencia, producto_codigo, producto_descripcion, producto_variedad, producto_medida, producto_tipo, producto_marca, lote_codigo, 
                         lote_descripcion, lote_lote, lote_seccion, productor_codigo, productor_descripcion, destino_cliente_codigo, destino_nombre, destino_localizacion, embarque_fletero, embarque_presentacion, 
                         embarque_unidades, embarque_kgunidad, embarque_kgembarque, recepcion_unidades, recepcion_kgunidad, recepcion_kgembarque, merma_kgunidad, merma_kgembarque, precio_productor, precio_cliente, 
                         precio_real, a_pagar_kgembarque, a_pagar_kgunidad, a_pagar_importe, pagos_fgs, pagos_socios, saldo_cliente, ventas_fgs, xcobrar_fgs, ventas_socio, xcobrar_socio, semilla_int, bodega, venta_importe, 
                         venta_pagado, venta_saldo, fgs_importe, fgs_pagado, fgs_saldo, socio_importe, socio_pagado, socio_saldo
FROM            ventas
WHERE        (producto_tipo = 'COMERCIAL')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.ventas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFolioVenta" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByFolioVenta" GeneratorSourceName="FillByFolioVenta" GetMethodModifier="Public" GetMethodName="GetDataByFolioVenta" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByFolioVenta" UserSourceName="FillByFolioVenta">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        folio, venta_tipo, viaje_status, viaje_folio, viaje_fecha, viaje_dia, viaje_referencia, producto_codigo, producto_descripcion, producto_variedad, producto_medida, producto_tipo, producto_marca, lote_codigo, 
                         lote_descripcion, lote_lote, lote_seccion, productor_codigo, productor_descripcion, destino_cliente_codigo, destino_nombre, destino_localizacion, embarque_fletero, embarque_presentacion, 
                         embarque_unidades, embarque_kgunidad, embarque_kgembarque, recepcion_unidades, recepcion_kgunidad, recepcion_kgembarque, merma_kgunidad, merma_kgembarque, precio_productor, precio_cliente, 
                         precio_real, a_pagar_kgembarque, a_pagar_kgunidad, a_pagar_importe, pagos_fgs, pagos_socios, saldo_cliente, ventas_fgs, xcobrar_fgs, ventas_socio, xcobrar_socio, semilla_int, bodega, venta_importe, 
                         venta_pagado, venta_saldo, fgs_importe, fgs_pagado, fgs_saldo, socio_importe, socio_pagado, socio_saldo
FROM            ventas
WHERE        (folio = @folio)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="folio" ColumnName="folio" DataSourceName="agricomer.ventas" DataTypeServer="bigint(20)" DbType="Int64" Direction="Input" ParameterName="@folio" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="folio" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.ventas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPagados" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPagados" GeneratorSourceName="FillByPagados" GetMethodModifier="Public" GetMethodName="GetDataByPagados" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPagados" UserSourceName="FillByPagados">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        folio, venta_tipo, viaje_status, viaje_folio, viaje_fecha, viaje_dia, viaje_referencia, producto_codigo, producto_descripcion, producto_variedad, producto_medida, producto_tipo, producto_marca, lote_codigo, 
                         lote_descripcion, lote_lote, lote_seccion, productor_codigo, productor_descripcion, destino_cliente_codigo, destino_nombre, destino_localizacion, embarque_fletero, embarque_presentacion, 
                         embarque_unidades, embarque_kgunidad, embarque_kgembarque, recepcion_unidades, recepcion_kgunidad, recepcion_kgembarque, merma_kgunidad, merma_kgembarque, precio_productor, precio_cliente, 
                         precio_real, a_pagar_kgembarque, a_pagar_kgunidad, a_pagar_importe, pagos_fgs, pagos_socios, saldo_cliente, ventas_fgs, xcobrar_fgs, ventas_socio, xcobrar_socio, semilla_int, bodega, venta_importe, 
                         venta_pagado, venta_saldo, fgs_importe, fgs_pagado, fgs_saldo, socio_importe, socio_pagado, socio_saldo
FROM            ventas
WHERE        (viaje_status = 'PAGADO')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.ventas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPreliquidados" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPreliquidados" GeneratorSourceName="FillByPreliquidados" GetMethodModifier="Public" GetMethodName="GetDataByPreliquidados" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPreliquidados" UserSourceName="FillByPreliquidados">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        folio, venta_tipo, viaje_status, viaje_folio, viaje_fecha, viaje_dia, viaje_referencia, producto_codigo, producto_descripcion, producto_variedad, producto_medida, producto_tipo, producto_marca, lote_codigo, 
                         lote_descripcion, lote_lote, lote_seccion, productor_codigo, productor_descripcion, destino_cliente_codigo, destino_nombre, destino_localizacion, embarque_fletero, embarque_presentacion, 
                         embarque_unidades, embarque_kgunidad, embarque_kgembarque, recepcion_unidades, recepcion_kgunidad, recepcion_kgembarque, merma_kgunidad, merma_kgembarque, precio_productor, precio_cliente, 
                         precio_real, a_pagar_kgembarque, a_pagar_kgunidad, a_pagar_importe, pagos_fgs, pagos_socios, saldo_cliente, ventas_fgs, xcobrar_fgs, ventas_socio, xcobrar_socio, semilla_int, bodega, venta_importe, 
                         venta_pagado, venta_saldo, fgs_importe, fgs_pagado, fgs_saldo, socio_importe, socio_pagado, socio_saldo
FROM            ventas
WHERE        (viaje_status = 'PRELIQUIDADO')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.ventas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySemilla" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySemilla" GeneratorSourceName="FillBySemilla" GetMethodModifier="Public" GetMethodName="GetDataBySemilla" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySemilla" UserSourceName="FillBySemilla">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        folio, venta_tipo, viaje_status, viaje_folio, viaje_fecha, viaje_dia, viaje_referencia, producto_codigo, producto_descripcion, producto_variedad, producto_medida, producto_tipo, producto_marca, lote_codigo, 
                         lote_descripcion, lote_lote, lote_seccion, productor_codigo, productor_descripcion, destino_cliente_codigo, destino_nombre, destino_localizacion, embarque_fletero, embarque_presentacion, 
                         embarque_unidades, embarque_kgunidad, embarque_kgembarque, recepcion_unidades, recepcion_kgunidad, recepcion_kgembarque, merma_kgunidad, merma_kgembarque, precio_productor, precio_cliente, 
                         precio_real, a_pagar_kgembarque, a_pagar_kgunidad, a_pagar_importe, pagos_fgs, pagos_socios, saldo_cliente, ventas_fgs, xcobrar_fgs, ventas_socio, xcobrar_socio, semilla_int, bodega, venta_importe, 
                         venta_pagado, venta_saldo, fgs_importe, fgs_pagado, fgs_saldo, socio_importe, socio_pagado, socio_saldo
FROM            ventas
WHERE        (producto_tipo = 'SEMILLA')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.ventas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySinPreliquidar" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySinPreliquidar" GeneratorSourceName="FillBySinPreliquidar" GetMethodModifier="Public" GetMethodName="GetDataBySinPreliquidar" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySinPreliquidar" UserSourceName="FillBySinPreliquidar">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        folio, venta_tipo, viaje_status, viaje_folio, viaje_fecha, viaje_dia, viaje_referencia, producto_codigo, producto_descripcion, producto_variedad, producto_medida, producto_tipo, producto_marca, lote_codigo, 
                         lote_descripcion, lote_lote, lote_seccion, productor_codigo, productor_descripcion, destino_cliente_codigo, destino_nombre, destino_localizacion, embarque_fletero, embarque_presentacion, 
                         embarque_unidades, embarque_kgunidad, embarque_kgembarque, recepcion_unidades, recepcion_kgunidad, recepcion_kgembarque, merma_kgunidad, merma_kgembarque, precio_productor, precio_cliente, 
                         precio_real, a_pagar_kgembarque, a_pagar_kgunidad, a_pagar_importe, pagos_fgs, pagos_socios, saldo_cliente, ventas_fgs, xcobrar_fgs, ventas_socio, xcobrar_socio, semilla_int, bodega, venta_importe, 
                         venta_pagado, venta_saldo, fgs_importe, fgs_pagado, fgs_saldo, socio_importe, socio_pagado, socio_saldo
FROM            ventas
WHERE        (viaje_status = 'SIN PRELIQUIDAR')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.ventas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySociedad" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySociedad" GeneratorSourceName="FillBySociedad" GetMethodModifier="Public" GetMethodName="GetDataBySociedad" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySociedad" UserSourceName="FillBySociedad">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        folio, venta_tipo, viaje_status, viaje_folio, viaje_fecha, viaje_dia, viaje_referencia, producto_codigo, producto_descripcion, producto_variedad, producto_medida, producto_tipo, producto_marca, lote_codigo, 
                         lote_descripcion, lote_lote, lote_seccion, productor_codigo, productor_descripcion, destino_cliente_codigo, destino_nombre, destino_localizacion, embarque_fletero, embarque_presentacion, 
                         embarque_unidades, embarque_kgunidad, embarque_kgembarque, recepcion_unidades, recepcion_kgunidad, recepcion_kgembarque, merma_kgunidad, merma_kgembarque, precio_productor, precio_cliente, 
                         precio_real, a_pagar_kgembarque, a_pagar_kgunidad, a_pagar_importe, pagos_fgs, pagos_socios, saldo_cliente, ventas_fgs, xcobrar_fgs, ventas_socio, xcobrar_socio, semilla_int, bodega, venta_importe, 
                         venta_pagado, venta_saldo, fgs_importe, fgs_pagado, fgs_saldo, socio_importe, socio_pagado, socio_saldo
FROM            ventas
WHERE        (viaje_status = 'SOCIEDAD')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="agricomerConnectionString (Settings)" DbObjectName="agricomer.ventas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySPyPLyP" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySPyPLyP" GeneratorSourceName="FillBySPyPLyP" GetMethodModifier="Public" GetMethodName="GetDataBySPyPLyP" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySPyPLyP" UserSourceName="FillBySPyPLyP">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        folio, venta_tipo, viaje_status, viaje_folio, viaje_fecha, viaje_dia, viaje_referencia, producto_codigo, producto_descripcion, producto_variedad, producto_medida, producto_tipo, producto_marca, lote_codigo, 
                         lote_descripcion, lote_lote, lote_seccion, productor_codigo, productor_descripcion, destino_cliente_codigo, destino_nombre, destino_localizacion, embarque_fletero, embarque_presentacion, 
                         embarque_unidades, embarque_kgunidad, embarque_kgembarque, recepcion_unidades, recepcion_kgunidad, recepcion_kgembarque, merma_kgunidad, merma_kgembarque, precio_productor, precio_cliente, 
                         precio_real, a_pagar_kgembarque, a_pagar_kgunidad, a_pagar_importe, pagos_fgs, pagos_socios, saldo_cliente, ventas_fgs, xcobrar_fgs, ventas_socio, xcobrar_socio, semilla_int, bodega, venta_importe, 
                         venta_pagado, venta_saldo, fgs_importe, fgs_pagado, fgs_saldo, socio_importe, socio_pagado, socio_saldo
FROM            ventas
WHERE        (viaje_status = 'SIN PRELIQUIDAR') OR
                         (viaje_status = 'PRELIQUIDADO') OR
                         (viaje_status = 'PAGADO')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsAgriComer" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsAgriComer" msprop:Generator_UserDSName="dsAgriComer">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="catalogo_status" msprop:Generator_TableClassName="catalogo_statusDataTable" msprop:Generator_TableVarName="tablecatalogo_status" msprop:Generator_TablePropName="catalogo_status" msprop:Generator_RowDeletingName="catalogo_statusRowDeleting" msprop:Generator_RowChangingName="catalogo_statusRowChanging" msprop:Generator_RowEvHandlerName="catalogo_statusRowChangeEventHandler" msprop:Generator_RowDeletedName="catalogo_statusRowDeleted" msprop:Generator_UserTableName="catalogo_status" msprop:Generator_RowChangedName="catalogo_statusRowChanged" msprop:Generator_RowEvArgName="catalogo_statusRowChangeEvent" msprop:Generator_RowClassName="catalogo_statusRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="codigo" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncodigo" msprop:Generator_ColumnPropNameInRow="codigo" msprop:Generator_ColumnPropNameInTable="codigoColumn" msprop:Generator_UserColumnName="codigo" type="xs:long" />
              <xs:element name="descripcion" msprop:Generator_ColumnVarNameInTable="columndescripcion" msprop:Generator_ColumnPropNameInRow="descripcion" msprop:Generator_ColumnPropNameInTable="descripcionColumn" msprop:Generator_UserColumnName="descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="clientes" msprop:Generator_TableClassName="clientesDataTable" msprop:Generator_TableVarName="tableclientes" msprop:Generator_TablePropName="clientes" msprop:Generator_RowDeletingName="clientesRowDeleting" msprop:Generator_RowChangingName="clientesRowChanging" msprop:Generator_RowEvHandlerName="clientesRowChangeEventHandler" msprop:Generator_RowDeletedName="clientesRowDeleted" msprop:Generator_UserTableName="clientes" msprop:Generator_RowChangedName="clientesRowChanged" msprop:Generator_RowEvArgName="clientesRowChangeEvent" msprop:Generator_RowClassName="clientesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="codigo" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncodigo" msprop:Generator_ColumnPropNameInRow="codigo" msprop:Generator_ColumnPropNameInTable="codigoColumn" msprop:Generator_UserColumnName="codigo" type="xs:long" />
              <xs:element name="descripcion" msprop:Generator_ColumnVarNameInTable="columndescripcion" msprop:Generator_ColumnPropNameInRow="descripcion" msprop:Generator_ColumnPropNameInTable="descripcionColumn" msprop:Generator_UserColumnName="descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nombre" msprop:Generator_ColumnVarNameInTable="columnnombre" msprop:Generator_ColumnPropNameInRow="nombre" msprop:Generator_ColumnPropNameInTable="nombreColumn" msprop:Generator_UserColumnName="nombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contacto" msprop:Generator_ColumnVarNameInTable="columncontacto" msprop:Generator_ColumnPropNameInRow="contacto" msprop:Generator_ColumnPropNameInTable="contactoColumn" msprop:Generator_UserColumnName="contacto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telefono" msprop:Generator_ColumnVarNameInTable="columntelefono" msprop:Generator_ColumnPropNameInRow="telefono" msprop:Generator_ColumnPropNameInTable="telefonoColumn" msprop:Generator_UserColumnName="telefono" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="direccion" msprop:Generator_ColumnVarNameInTable="columndireccion" msprop:Generator_ColumnPropNameInRow="direccion" msprop:Generator_ColumnPropNameInTable="direccionColumn" msprop:Generator_UserColumnName="direccion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="rfc" msprop:Generator_ColumnVarNameInTable="columnrfc" msprop:Generator_ColumnPropNameInRow="rfc" msprop:Generator_ColumnPropNameInTable="rfcColumn" msprop:Generator_UserColumnName="rfc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="cosechas" msprop:Generator_TableClassName="cosechasDataTable" msprop:Generator_TableVarName="tablecosechas" msprop:Generator_TablePropName="cosechas" msprop:Generator_RowDeletingName="cosechasRowDeleting" msprop:Generator_RowChangingName="cosechasRowChanging" msprop:Generator_RowEvHandlerName="cosechasRowChangeEventHandler" msprop:Generator_RowDeletedName="cosechasRowDeleted" msprop:Generator_UserTableName="cosechas" msprop:Generator_RowChangedName="cosechasRowChanged" msprop:Generator_RowEvArgName="cosechasRowChangeEvent" msprop:Generator_RowClassName="cosechasRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="codigo" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncodigo" msprop:Generator_ColumnPropNameInRow="codigo" msprop:Generator_ColumnPropNameInTable="codigoColumn" msprop:Generator_UserColumnName="codigo" type="xs:long" />
              <xs:element name="descripcion" msprop:Generator_ColumnVarNameInTable="columndescripcion" msprop:Generator_ColumnPropNameInRow="descripcion" msprop:Generator_ColumnPropNameInTable="descripcionColumn" msprop:Generator_UserColumnName="descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="temporada" msprop:Generator_ColumnVarNameInTable="columntemporada" msprop:Generator_ColumnPropNameInRow="temporada" msprop:Generator_ColumnPropNameInTable="temporadaColumn" msprop:Generator_UserColumnName="temporada" type="xs:dateTime" minOccurs="0" />
              <xs:element name="codigo_lote" msprop:Generator_ColumnVarNameInTable="columncodigo_lote" msprop:Generator_ColumnPropNameInRow="codigo_lote" msprop:Generator_ColumnPropNameInTable="codigo_loteColumn" msprop:Generator_UserColumnName="codigo_lote" type="xs:int" minOccurs="0" />
              <xs:element name="codigo_producto" msprop:Generator_ColumnVarNameInTable="columncodigo_producto" msprop:Generator_ColumnPropNameInRow="codigo_producto" msprop:Generator_ColumnPropNameInTable="codigo_productoColumn" msprop:Generator_UserColumnName="codigo_producto" type="xs:int" minOccurs="0" />
              <xs:element name="codigo_productor" msprop:Generator_ColumnVarNameInTable="columncodigo_productor" msprop:Generator_ColumnPropNameInRow="codigo_productor" msprop:Generator_ColumnPropNameInTable="codigo_productorColumn" msprop:Generator_UserColumnName="codigo_productor" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="lotes" msprop:Generator_TableClassName="lotesDataTable" msprop:Generator_TableVarName="tablelotes" msprop:Generator_TablePropName="lotes" msprop:Generator_RowDeletingName="lotesRowDeleting" msprop:Generator_RowChangingName="lotesRowChanging" msprop:Generator_RowEvHandlerName="lotesRowChangeEventHandler" msprop:Generator_RowDeletedName="lotesRowDeleted" msprop:Generator_UserTableName="lotes" msprop:Generator_RowChangedName="lotesRowChanged" msprop:Generator_RowEvArgName="lotesRowChangeEvent" msprop:Generator_RowClassName="lotesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="codigo" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncodigo" msprop:Generator_ColumnPropNameInRow="codigo" msprop:Generator_ColumnPropNameInTable="codigoColumn" msprop:Generator_UserColumnName="codigo" type="xs:long" />
              <xs:element name="descripcion" msprop:Generator_ColumnVarNameInTable="columndescripcion" msprop:Generator_ColumnPropNameInRow="descripcion" msprop:Generator_ColumnPropNameInTable="descripcionColumn" msprop:Generator_UserColumnName="descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lote" msprop:Generator_ColumnVarNameInTable="columnlote" msprop:Generator_ColumnPropNameInRow="lote" msprop:Generator_ColumnPropNameInTable="loteColumn" msprop:Generator_UserColumnName="lote" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="seccion" msprop:Generator_ColumnVarNameInTable="columnseccion" msprop:Generator_ColumnPropNameInRow="seccion" msprop:Generator_ColumnPropNameInTable="seccionColumn" msprop:Generator_UserColumnName="seccion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="productores" msprop:Generator_TableClassName="productoresDataTable" msprop:Generator_TableVarName="tableproductores" msprop:Generator_TablePropName="productores" msprop:Generator_RowDeletingName="productoresRowDeleting" msprop:Generator_RowChangingName="productoresRowChanging" msprop:Generator_RowEvHandlerName="productoresRowChangeEventHandler" msprop:Generator_RowDeletedName="productoresRowDeleted" msprop:Generator_UserTableName="productores" msprop:Generator_RowChangedName="productoresRowChanged" msprop:Generator_RowEvArgName="productoresRowChangeEvent" msprop:Generator_RowClassName="productoresRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="codigo" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncodigo" msprop:Generator_ColumnPropNameInRow="codigo" msprop:Generator_ColumnPropNameInTable="codigoColumn" msprop:Generator_UserColumnName="codigo" type="xs:long" />
              <xs:element name="descripcion" msprop:Generator_ColumnVarNameInTable="columndescripcion" msprop:Generator_ColumnPropNameInRow="descripcion" msprop:Generator_ColumnPropNameInTable="descripcionColumn" msprop:Generator_UserColumnName="descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nombre" msprop:Generator_ColumnVarNameInTable="columnnombre" msprop:Generator_ColumnPropNameInRow="nombre" msprop:Generator_ColumnPropNameInTable="nombreColumn" msprop:Generator_UserColumnName="nombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="productos" msprop:Generator_TableClassName="productosDataTable" msprop:Generator_TableVarName="tableproductos" msprop:Generator_TablePropName="productos" msprop:Generator_RowDeletingName="productosRowDeleting" msprop:Generator_RowChangingName="productosRowChanging" msprop:Generator_RowEvHandlerName="productosRowChangeEventHandler" msprop:Generator_RowDeletedName="productosRowDeleted" msprop:Generator_UserTableName="productos" msprop:Generator_RowChangedName="productosRowChanged" msprop:Generator_RowEvArgName="productosRowChangeEvent" msprop:Generator_RowClassName="productosRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="codigo" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncodigo" msprop:Generator_ColumnPropNameInRow="codigo" msprop:Generator_ColumnPropNameInTable="codigoColumn" msprop:Generator_UserColumnName="codigo" type="xs:long" />
              <xs:element name="descripcion" msprop:Generator_ColumnVarNameInTable="columndescripcion" msprop:Generator_ColumnPropNameInRow="descripcion" msprop:Generator_ColumnPropNameInTable="descripcionColumn" msprop:Generator_UserColumnName="descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="producto" msprop:Generator_ColumnVarNameInTable="columnproducto" msprop:Generator_ColumnPropNameInRow="producto" msprop:Generator_ColumnPropNameInTable="productoColumn" msprop:Generator_UserColumnName="producto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="variedad" msprop:Generator_ColumnVarNameInTable="columnvariedad" msprop:Generator_ColumnPropNameInRow="variedad" msprop:Generator_ColumnPropNameInTable="variedadColumn" msprop:Generator_UserColumnName="variedad" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="medida" msprop:Generator_ColumnVarNameInTable="columnmedida" msprop:Generator_ColumnPropNameInRow="medida" msprop:Generator_ColumnPropNameInTable="medidaColumn" msprop:Generator_UserColumnName="medida" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="marca" msprop:Generator_ColumnVarNameInTable="columnmarca" msprop:Generator_ColumnPropNameInRow="marca" msprop:Generator_ColumnPropNameInTable="marcaColumn" msprop:Generator_UserColumnName="marca" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="existencia" msprop:Generator_ColumnVarNameInTable="columnexistencia" msprop:Generator_ColumnPropNameInRow="existencia" msprop:Generator_ColumnPropNameInTable="existenciaColumn" msprop:Generator_UserColumnName="existencia" type="xs:double" minOccurs="0" />
              <xs:element name="unidad" msprop:Generator_ColumnVarNameInTable="columnunidad" msprop:Generator_ColumnPropNameInRow="unidad" msprop:Generator_ColumnPropNameInTable="unidadColumn" msprop:Generator_UserColumnName="unidad" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="unidades_medida" msprop:Generator_TableClassName="unidades_medidaDataTable" msprop:Generator_TableVarName="tableunidades_medida" msprop:Generator_TablePropName="unidades_medida" msprop:Generator_RowDeletingName="unidades_medidaRowDeleting" msprop:Generator_RowChangingName="unidades_medidaRowChanging" msprop:Generator_RowEvHandlerName="unidades_medidaRowChangeEventHandler" msprop:Generator_RowDeletedName="unidades_medidaRowDeleted" msprop:Generator_UserTableName="unidades_medida" msprop:Generator_RowChangedName="unidades_medidaRowChanged" msprop:Generator_RowEvArgName="unidades_medidaRowChangeEvent" msprop:Generator_RowClassName="unidades_medidaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="codigo" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncodigo" msprop:Generator_ColumnPropNameInRow="codigo" msprop:Generator_ColumnPropNameInTable="codigoColumn" msprop:Generator_UserColumnName="codigo" type="xs:long" />
              <xs:element name="descripcion" msprop:Generator_ColumnVarNameInTable="columndescripcion" msprop:Generator_ColumnPropNameInRow="descripcion" msprop:Generator_ColumnPropNameInTable="descripcionColumn" msprop:Generator_UserColumnName="descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="unidad" msprop:Generator_ColumnVarNameInTable="columnunidad" msprop:Generator_ColumnPropNameInRow="unidad" msprop:Generator_ColumnPropNameInTable="unidadColumn" msprop:Generator_UserColumnName="unidad" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ventas" msprop:Generator_TableClassName="ventasDataTable" msprop:Generator_TableVarName="tableventas" msprop:Generator_RowChangedName="ventasRowChanged" msprop:Generator_TablePropName="ventas" msprop:Generator_RowDeletingName="ventasRowDeleting" msprop:Generator_RowChangingName="ventasRowChanging" msprop:Generator_RowEvHandlerName="ventasRowChangeEventHandler" msprop:Generator_RowDeletedName="ventasRowDeleted" msprop:Generator_RowClassName="ventasRow" msprop:Generator_UserTableName="ventas" msprop:Generator_RowEvArgName="ventasRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="folio" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnfolio" msprop:Generator_ColumnPropNameInRow="folio" msprop:Generator_ColumnPropNameInTable="folioColumn" msprop:Generator_UserColumnName="folio" type="xs:long" />
              <xs:element name="venta_tipo" msprop:Generator_ColumnVarNameInTable="columnventa_tipo" msprop:Generator_ColumnPropNameInRow="venta_tipo" msprop:Generator_ColumnPropNameInTable="venta_tipoColumn" msprop:Generator_UserColumnName="venta_tipo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="viaje_status" msprop:Generator_ColumnVarNameInTable="columnviaje_status" msprop:Generator_ColumnPropNameInRow="viaje_status" msprop:Generator_ColumnPropNameInTable="viaje_statusColumn" msprop:Generator_UserColumnName="viaje_status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="viaje_folio" msprop:Generator_ColumnVarNameInTable="columnviaje_folio" msprop:Generator_ColumnPropNameInRow="viaje_folio" msprop:Generator_ColumnPropNameInTable="viaje_folioColumn" msprop:Generator_UserColumnName="viaje_folio" type="xs:long" minOccurs="0" />
              <xs:element name="viaje_fecha" msprop:Generator_ColumnVarNameInTable="columnviaje_fecha" msprop:Generator_ColumnPropNameInRow="viaje_fecha" msprop:Generator_ColumnPropNameInTable="viaje_fechaColumn" msprop:Generator_UserColumnName="viaje_fecha" type="xs:dateTime" minOccurs="0" />
              <xs:element name="viaje_dia" msprop:Generator_ColumnVarNameInTable="columnviaje_dia" msprop:Generator_ColumnPropNameInRow="viaje_dia" msprop:Generator_ColumnPropNameInTable="viaje_diaColumn" msprop:Generator_UserColumnName="viaje_dia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="viaje_referencia" msprop:Generator_ColumnVarNameInTable="columnviaje_referencia" msprop:Generator_ColumnPropNameInRow="viaje_referencia" msprop:Generator_ColumnPropNameInTable="viaje_referenciaColumn" msprop:Generator_UserColumnName="viaje_referencia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="producto_codigo" msprop:Generator_ColumnVarNameInTable="columnproducto_codigo" msprop:Generator_ColumnPropNameInRow="producto_codigo" msprop:Generator_ColumnPropNameInTable="producto_codigoColumn" msprop:Generator_UserColumnName="producto_codigo" type="xs:long" minOccurs="0" />
              <xs:element name="producto_descripcion" msprop:Generator_ColumnVarNameInTable="columnproducto_descripcion" msprop:Generator_ColumnPropNameInRow="producto_descripcion" msprop:Generator_ColumnPropNameInTable="producto_descripcionColumn" msprop:Generator_UserColumnName="producto_descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="producto_variedad" msprop:Generator_ColumnVarNameInTable="columnproducto_variedad" msprop:Generator_ColumnPropNameInRow="producto_variedad" msprop:Generator_ColumnPropNameInTable="producto_variedadColumn" msprop:Generator_UserColumnName="producto_variedad" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="producto_medida" msprop:Generator_ColumnVarNameInTable="columnproducto_medida" msprop:Generator_ColumnPropNameInRow="producto_medida" msprop:Generator_ColumnPropNameInTable="producto_medidaColumn" msprop:Generator_UserColumnName="producto_medida" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="producto_tipo" msprop:Generator_ColumnVarNameInTable="columnproducto_tipo" msprop:Generator_ColumnPropNameInRow="producto_tipo" msprop:Generator_ColumnPropNameInTable="producto_tipoColumn" msprop:Generator_UserColumnName="producto_tipo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="producto_marca" msprop:Generator_ColumnVarNameInTable="columnproducto_marca" msprop:Generator_ColumnPropNameInRow="producto_marca" msprop:Generator_ColumnPropNameInTable="producto_marcaColumn" msprop:Generator_UserColumnName="producto_marca" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lote_codigo" msprop:Generator_ColumnVarNameInTable="columnlote_codigo" msprop:Generator_ColumnPropNameInRow="lote_codigo" msprop:Generator_ColumnPropNameInTable="lote_codigoColumn" msprop:Generator_UserColumnName="lote_codigo" type="xs:long" minOccurs="0" />
              <xs:element name="lote_descripcion" msprop:Generator_ColumnVarNameInTable="columnlote_descripcion" msprop:Generator_ColumnPropNameInRow="lote_descripcion" msprop:Generator_ColumnPropNameInTable="lote_descripcionColumn" msprop:Generator_UserColumnName="lote_descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lote_lote" msprop:Generator_ColumnVarNameInTable="columnlote_lote" msprop:Generator_ColumnPropNameInRow="lote_lote" msprop:Generator_ColumnPropNameInTable="lote_loteColumn" msprop:Generator_UserColumnName="lote_lote" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lote_seccion" msprop:Generator_ColumnVarNameInTable="columnlote_seccion" msprop:Generator_ColumnPropNameInRow="lote_seccion" msprop:Generator_ColumnPropNameInTable="lote_seccionColumn" msprop:Generator_UserColumnName="lote_seccion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="productor_codigo" msprop:Generator_ColumnVarNameInTable="columnproductor_codigo" msprop:Generator_ColumnPropNameInRow="productor_codigo" msprop:Generator_ColumnPropNameInTable="productor_codigoColumn" msprop:Generator_UserColumnName="productor_codigo" type="xs:long" minOccurs="0" />
              <xs:element name="productor_descripcion" msprop:Generator_ColumnVarNameInTable="columnproductor_descripcion" msprop:Generator_ColumnPropNameInRow="productor_descripcion" msprop:Generator_ColumnPropNameInTable="productor_descripcionColumn" msprop:Generator_UserColumnName="productor_descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="destino_cliente_codigo" msprop:Generator_ColumnVarNameInTable="columndestino_cliente_codigo" msprop:Generator_ColumnPropNameInRow="destino_cliente_codigo" msprop:Generator_ColumnPropNameInTable="destino_cliente_codigoColumn" msprop:Generator_UserColumnName="destino_cliente_codigo" type="xs:long" minOccurs="0" />
              <xs:element name="destino_nombre" msprop:Generator_ColumnVarNameInTable="columndestino_nombre" msprop:Generator_ColumnPropNameInRow="destino_nombre" msprop:Generator_ColumnPropNameInTable="destino_nombreColumn" msprop:Generator_UserColumnName="destino_nombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="destino_localizacion" msprop:Generator_ColumnVarNameInTable="columndestino_localizacion" msprop:Generator_ColumnPropNameInRow="destino_localizacion" msprop:Generator_ColumnPropNameInTable="destino_localizacionColumn" msprop:Generator_UserColumnName="destino_localizacion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="embarque_fletero" msprop:Generator_ColumnVarNameInTable="columnembarque_fletero" msprop:Generator_ColumnPropNameInRow="embarque_fletero" msprop:Generator_ColumnPropNameInTable="embarque_fleteroColumn" msprop:Generator_UserColumnName="embarque_fletero" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="embarque_presentacion" msprop:Generator_ColumnVarNameInTable="columnembarque_presentacion" msprop:Generator_ColumnPropNameInRow="embarque_presentacion" msprop:Generator_ColumnPropNameInTable="embarque_presentacionColumn" msprop:Generator_UserColumnName="embarque_presentacion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="embarque_unidades" msprop:Generator_ColumnVarNameInTable="columnembarque_unidades" msprop:Generator_ColumnPropNameInRow="embarque_unidades" msprop:Generator_ColumnPropNameInTable="embarque_unidadesColumn" msprop:Generator_UserColumnName="embarque_unidades" type="xs:double" minOccurs="0" />
              <xs:element name="embarque_kgunidad" msprop:Generator_ColumnVarNameInTable="columnembarque_kgunidad" msprop:Generator_ColumnPropNameInRow="embarque_kgunidad" msprop:Generator_ColumnPropNameInTable="embarque_kgunidadColumn" msprop:Generator_UserColumnName="embarque_kgunidad" type="xs:double" minOccurs="0" />
              <xs:element name="embarque_kgembarque" msprop:Generator_ColumnVarNameInTable="columnembarque_kgembarque" msprop:Generator_ColumnPropNameInRow="embarque_kgembarque" msprop:Generator_ColumnPropNameInTable="embarque_kgembarqueColumn" msprop:Generator_UserColumnName="embarque_kgembarque" type="xs:double" minOccurs="0" />
              <xs:element name="recepcion_unidades" msprop:Generator_ColumnVarNameInTable="columnrecepcion_unidades" msprop:Generator_ColumnPropNameInRow="recepcion_unidades" msprop:Generator_ColumnPropNameInTable="recepcion_unidadesColumn" msprop:Generator_UserColumnName="recepcion_unidades" type="xs:double" minOccurs="0" />
              <xs:element name="recepcion_kgunidad" msprop:Generator_ColumnVarNameInTable="columnrecepcion_kgunidad" msprop:Generator_ColumnPropNameInRow="recepcion_kgunidad" msprop:Generator_ColumnPropNameInTable="recepcion_kgunidadColumn" msprop:Generator_UserColumnName="recepcion_kgunidad" type="xs:double" minOccurs="0" />
              <xs:element name="recepcion_kgembarque" msprop:Generator_ColumnVarNameInTable="columnrecepcion_kgembarque" msprop:Generator_ColumnPropNameInRow="recepcion_kgembarque" msprop:Generator_ColumnPropNameInTable="recepcion_kgembarqueColumn" msprop:Generator_UserColumnName="recepcion_kgembarque" type="xs:double" minOccurs="0" />
              <xs:element name="merma_kgunidad" msprop:Generator_ColumnVarNameInTable="columnmerma_kgunidad" msprop:Generator_ColumnPropNameInRow="merma_kgunidad" msprop:Generator_ColumnPropNameInTable="merma_kgunidadColumn" msprop:Generator_UserColumnName="merma_kgunidad" type="xs:double" minOccurs="0" />
              <xs:element name="merma_kgembarque" msprop:Generator_ColumnVarNameInTable="columnmerma_kgembarque" msprop:Generator_ColumnPropNameInRow="merma_kgembarque" msprop:Generator_ColumnPropNameInTable="merma_kgembarqueColumn" msprop:Generator_UserColumnName="merma_kgembarque" type="xs:double" minOccurs="0" />
              <xs:element name="precio_productor" msprop:Generator_ColumnVarNameInTable="columnprecio_productor" msprop:Generator_ColumnPropNameInRow="precio_productor" msprop:Generator_ColumnPropNameInTable="precio_productorColumn" msprop:Generator_UserColumnName="precio_productor" type="xs:double" minOccurs="0" />
              <xs:element name="precio_cliente" msprop:Generator_ColumnVarNameInTable="columnprecio_cliente" msprop:Generator_ColumnPropNameInRow="precio_cliente" msprop:Generator_ColumnPropNameInTable="precio_clienteColumn" msprop:Generator_UserColumnName="precio_cliente" type="xs:double" minOccurs="0" />
              <xs:element name="precio_real" msprop:Generator_ColumnVarNameInTable="columnprecio_real" msprop:Generator_ColumnPropNameInRow="precio_real" msprop:Generator_ColumnPropNameInTable="precio_realColumn" msprop:Generator_UserColumnName="precio_real" type="xs:double" minOccurs="0" />
              <xs:element name="a_pagar_kgembarque" msprop:Generator_ColumnVarNameInTable="columna_pagar_kgembarque" msprop:Generator_ColumnPropNameInRow="a_pagar_kgembarque" msprop:Generator_ColumnPropNameInTable="a_pagar_kgembarqueColumn" msprop:Generator_UserColumnName="a_pagar_kgembarque" type="xs:double" minOccurs="0" />
              <xs:element name="a_pagar_kgunidad" msprop:Generator_ColumnVarNameInTable="columna_pagar_kgunidad" msprop:Generator_ColumnPropNameInRow="a_pagar_kgunidad" msprop:Generator_ColumnPropNameInTable="a_pagar_kgunidadColumn" msprop:Generator_UserColumnName="a_pagar_kgunidad" type="xs:double" minOccurs="0" />
              <xs:element name="a_pagar_importe" msprop:Generator_ColumnVarNameInTable="columna_pagar_importe" msprop:Generator_ColumnPropNameInRow="a_pagar_importe" msprop:Generator_ColumnPropNameInTable="a_pagar_importeColumn" msprop:Generator_UserColumnName="a_pagar_importe" type="xs:double" minOccurs="0" />
              <xs:element name="pagos_fgs" msprop:Generator_ColumnVarNameInTable="columnpagos_fgs" msprop:Generator_ColumnPropNameInRow="pagos_fgs" msprop:Generator_ColumnPropNameInTable="pagos_fgsColumn" msprop:Generator_UserColumnName="pagos_fgs" type="xs:double" minOccurs="0" />
              <xs:element name="pagos_socios" msprop:Generator_ColumnVarNameInTable="columnpagos_socios" msprop:Generator_ColumnPropNameInRow="pagos_socios" msprop:Generator_ColumnPropNameInTable="pagos_sociosColumn" msprop:Generator_UserColumnName="pagos_socios" type="xs:double" minOccurs="0" />
              <xs:element name="saldo_cliente" msprop:Generator_ColumnVarNameInTable="columnsaldo_cliente" msprop:Generator_ColumnPropNameInRow="saldo_cliente" msprop:Generator_ColumnPropNameInTable="saldo_clienteColumn" msprop:Generator_UserColumnName="saldo_cliente" type="xs:double" minOccurs="0" />
              <xs:element name="ventas_fgs" msprop:Generator_ColumnVarNameInTable="columnventas_fgs" msprop:Generator_ColumnPropNameInRow="ventas_fgs" msprop:Generator_ColumnPropNameInTable="ventas_fgsColumn" msprop:Generator_UserColumnName="ventas_fgs" type="xs:double" minOccurs="0" />
              <xs:element name="xcobrar_fgs" msprop:Generator_ColumnVarNameInTable="columnxcobrar_fgs" msprop:Generator_ColumnPropNameInRow="xcobrar_fgs" msprop:Generator_ColumnPropNameInTable="xcobrar_fgsColumn" msprop:Generator_UserColumnName="xcobrar_fgs" type="xs:double" minOccurs="0" />
              <xs:element name="ventas_socio" msprop:Generator_ColumnVarNameInTable="columnventas_socio" msprop:Generator_ColumnPropNameInRow="ventas_socio" msprop:Generator_ColumnPropNameInTable="ventas_socioColumn" msprop:Generator_UserColumnName="ventas_socio" type="xs:double" minOccurs="0" />
              <xs:element name="xcobrar_socio" msprop:Generator_ColumnVarNameInTable="columnxcobrar_socio" msprop:Generator_ColumnPropNameInRow="xcobrar_socio" msprop:Generator_ColumnPropNameInTable="xcobrar_socioColumn" msprop:Generator_UserColumnName="xcobrar_socio" type="xs:double" minOccurs="0" />
              <xs:element name="semilla_int" msprop:Generator_ColumnVarNameInTable="columnsemilla_int" msprop:Generator_ColumnPropNameInRow="semilla_int" msprop:Generator_ColumnPropNameInTable="semilla_intColumn" msprop:Generator_UserColumnName="semilla_int" type="xs:double" minOccurs="0" />
              <xs:element name="bodega" msprop:Generator_ColumnVarNameInTable="columnbodega" msprop:Generator_ColumnPropNameInRow="bodega" msprop:Generator_ColumnPropNameInTable="bodegaColumn" msprop:Generator_UserColumnName="bodega" type="xs:double" minOccurs="0" />
              <xs:element name="venta_importe" msprop:Generator_ColumnVarNameInTable="columnventa_importe" msprop:Generator_ColumnPropNameInRow="venta_importe" msprop:Generator_ColumnPropNameInTable="venta_importeColumn" msprop:Generator_UserColumnName="venta_importe" type="xs:double" minOccurs="0" />
              <xs:element name="venta_pagado" msprop:Generator_ColumnVarNameInTable="columnventa_pagado" msprop:Generator_ColumnPropNameInRow="venta_pagado" msprop:Generator_ColumnPropNameInTable="venta_pagadoColumn" msprop:Generator_UserColumnName="venta_pagado" type="xs:double" minOccurs="0" />
              <xs:element name="venta_saldo" msprop:Generator_ColumnVarNameInTable="columnventa_saldo" msprop:Generator_ColumnPropNameInRow="venta_saldo" msprop:Generator_ColumnPropNameInTable="venta_saldoColumn" msprop:Generator_UserColumnName="venta_saldo" type="xs:double" minOccurs="0" />
              <xs:element name="fgs_importe" msprop:Generator_ColumnVarNameInTable="columnfgs_importe" msprop:Generator_ColumnPropNameInRow="fgs_importe" msprop:Generator_ColumnPropNameInTable="fgs_importeColumn" msprop:Generator_UserColumnName="fgs_importe" type="xs:double" minOccurs="0" />
              <xs:element name="fgs_pagado" msprop:Generator_ColumnVarNameInTable="columnfgs_pagado" msprop:Generator_ColumnPropNameInRow="fgs_pagado" msprop:Generator_ColumnPropNameInTable="fgs_pagadoColumn" msprop:Generator_UserColumnName="fgs_pagado" type="xs:double" minOccurs="0" />
              <xs:element name="fgs_saldo" msprop:Generator_ColumnVarNameInTable="columnfgs_saldo" msprop:Generator_ColumnPropNameInRow="fgs_saldo" msprop:Generator_ColumnPropNameInTable="fgs_saldoColumn" msprop:Generator_UserColumnName="fgs_saldo" type="xs:double" minOccurs="0" />
              <xs:element name="socio_importe" msprop:Generator_ColumnVarNameInTable="columnsocio_importe" msprop:Generator_ColumnPropNameInRow="socio_importe" msprop:Generator_ColumnPropNameInTable="socio_importeColumn" msprop:Generator_UserColumnName="socio_importe" type="xs:double" minOccurs="0" />
              <xs:element name="socio_pagado" msprop:Generator_ColumnVarNameInTable="columnsocio_pagado" msprop:Generator_ColumnPropNameInRow="socio_pagado" msprop:Generator_ColumnPropNameInTable="socio_pagadoColumn" msprop:Generator_UserColumnName="socio_pagado" type="xs:double" minOccurs="0" />
              <xs:element name="socio_saldo" msprop:Generator_ColumnVarNameInTable="columnsocio_saldo" msprop:Generator_ColumnPropNameInRow="socio_saldo" msprop:Generator_ColumnPropNameInTable="socio_saldoColumn" msprop:Generator_UserColumnName="socio_saldo" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:catalogo_status" />
      <xs:field xpath="mstns:codigo" />
    </xs:unique>
    <xs:unique name="clientes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:clientes" />
      <xs:field xpath="mstns:codigo" />
    </xs:unique>
    <xs:unique name="cosechas_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:cosechas" />
      <xs:field xpath="mstns:codigo" />
    </xs:unique>
    <xs:unique name="lotes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:lotes" />
      <xs:field xpath="mstns:codigo" />
    </xs:unique>
    <xs:unique name="productores_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:productores" />
      <xs:field xpath="mstns:codigo" />
    </xs:unique>
    <xs:unique name="productos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:productos" />
      <xs:field xpath="mstns:codigo" />
    </xs:unique>
    <xs:unique name="unidades_medida_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:unidades_medida" />
      <xs:field xpath="mstns:codigo" />
    </xs:unique>
    <xs:unique name="ventas_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ventas" />
      <xs:field xpath="mstns:folio" />
    </xs:unique>
  </xs:element>
</xs:schema>